<?php

// +----------------------------------------------------------------------
// | Shop-Demo for ThinkAdmin
// +----------------------------------------------------------------------
// | 版权所有 2022~2023 Anyon <zoujingli@qq.com>
// +----------------------------------------------------------------------
// | 官方网站: https://thinkadmin.top
// +----------------------------------------------------------------------
// | 免责声明 ( https://thinkadmin.top/disclaimer )
// | 会员免费 ( https://thinkadmin.top/vip-introduce )
// +----------------------------------------------------------------------
// | gitee 代码仓库：https://gitee.com/zoujingli/ThinkAdmin
// | github 代码仓库：https://github.com/zoujingli/ThinkAdmin
// +----------------------------------------------------------------------

namespace app\data\controller\jbgs;

use app\data\model\DataJiangbugongshi as DataNewsItem;
use app\data\service\NewsService;
use think\admin\Controller;
use think\admin\extend\CodeExtend;
use think\admin\helper\QueryHelper;
use think\admin\service\AdminService;
use think\facade\Db;


/**
 * 奖补公示
 * Class Item
 * @package app\data\controller\news
 */
class Jiangbugongshi extends Controller
{

    /**
     * 内容管理
     * @auth true
     * @menu true
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function index()
    {
        $this->type = $this->get['type'] ?? 'index';
        $this->fenlei = Db::name('data_zhengceku_fl')->where('deleted',0)->order('sort desc')->select()->toArray();
        DataNewsItem::mQuery($this->get)->layTable(function () {
            $this->title = '奖补公示';
        }, function (QueryHelper $query) {
            $query->like('title')->dateBetween('create_at');
            $query->where(['status' => intval($this->type === 'index'), 'deleted' => 0]);
            $admin = AdminService::getUserId();
            if ($admin != 10000) $query->whereRaw("admin_id = {$admin}");
        });
    }

    /**
     * 列表数据处理
     * @param array $data
     */
    protected function _page_filter(array &$data)
    {

        foreach ($data as &$item){

//            $msjx_ids = explode(',',$item['msjx_ids']);
//            $msjxs = Db::name('data_msjx')
//                ->where('id', 'in', $msjx_ids) // 使用in查询匹配多个ID
//                ->column('title'); // 假设你要查询的是用户的name字段，并且只获取这个字段的值
//            $item['msjx_list'] = implode(',',$msjxs);

        }

    }

    public function getMsjxList()
    {
        $gongzuo = Db::name('data_msjx')->where('deleted',0)->select()->toArray();
        return_msg(200,'success',$gongzuo);
    }


    /**
     * 添加文章内容
     * @auth true
     */
    public function add()
    {
        $this->title = '添加内容';
        DataNewsItem::mForm('form');
    }

    /**
     * 编辑文章内容
     * @auth true
     */
    public function edit()
    {
        $this->title = '编辑内容';
        DataNewsItem::mForm('form');
    }

    /**
     * 表单数据处理
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    protected function _form_filter(array &$data)
    {
        if (empty($data['code'])) {//暂无code就生成一个

        }
        if ($this->request->isGet()) {

//            if(!empty($data['ctrq'])){
//                $data['ctrq'] = date('Y-m-d',$data['ctrq']);
//            }


        } else {

            //日期转换时间戳
//            if(!empty($data['ctrq'])){
//                $data['ctrq'] = strtotime($data['ctrq']);
//            }

            //获取当前添加内容的管理员id
            $data['admin_id'] = AdminService::getUserId();

        }
    }

    /**
     * 表单结果处理
     * @param boolean $state
     */
    protected function _form_result(bool $state)
    {
        if ($state) {
            $this->success('保存成功！', 'javascript:history.back()');
        }
    }

    /**
     * 修改文章状态
     * @auth true
     */
    public function state()
    {
        DataNewsItem::mSave($this->_vali([
            'status.in:0,1'  => '状态值范围异常！',
            'status.require' => '状态值不能为空！',
        ]));
    }

    /**
     * 删除文章内容
     * @auth true
     */
    public function remove()
    {
        DataNewsItem::mDelete();
    }

    /**
     * 文章内容选择
     * @login true
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     */
    public function select()
    {
        $this->get['status'] = 1;
        $this->index();
    }

}